﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DataAccess;
using ModelLayer.Patient;

namespace DataAccessLayer.Patient
{
    public class PatientDataAccess
    {

        public static string GetPatientOID(string PID)
        {
            GestorBD.Query = "SELECT Patient_.OID_ FROM Patient_ INNER JOIN PatientProfile_ ON Patient_.OID_ = PatientProfile_.PatientOID_ WHERE (PatientProfile_.MrnId_ = '"+PID+"')";
            return GestorBD.EjecutarSentencia().Rows[0][0].ToString();
        }
    }
}
